Tabela LContractOrgUnitGroup

Definicja tabeli LContractOrgUnitGroup

Name

LContractOrgUnitGroup

Code

LContractOrgUnitGroup

Comment

PL: Polaczenie umowy z grupa placówek – ustalenie terenu opieki umowy
EN: Link between contract and organization units group – assignation contract to care terrain


Lista kolumn tabeli LContractOrgUnitGroup

Name

Code

LContractOrgUnitGroupID

LContractOrgUnitGroupID

OrgUnitGroupID

OrgUnitGroupID

ContractID

ContractID

StartDT

StartDT

StopD

StopD


Kolumna LContractOrgUnitGroupID tabeli LContractOrgUnitGroup

Definicja kolumny LContractOrgUnitGroupID tabeli LContractOrgUnitGroup

Name

LContractOrgUnitGroupID

Code

LContractOrgUnitGroupID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna OrgUnitGroupID tabeli LContractOrgUnitGroup

Definicja kolumny OrgUnitGroupID tabeli LContractOrgUnitGroup

Name

OrgUnitGroupID

Code

OrgUnitGroupID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ContractID tabeli LContractOrgUnitGroup

Definicja kolumny ContractID tabeli LContractOrgUnitGroup

Name

ContractID

Code

ContractID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna StartDT tabeli LContractOrgUnitGroup

Definicja kolumny StartDT tabeli LContractOrgUnitGroup

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

Yes

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopD tabeli LContractOrgUnitGroup

Definicja kolumny StopD tabeli LContractOrgUnitGroup

Name

StopD

Code

StopD

Data Type

DATE

Mandatory

No

Comment

 


Lista kluczy tabeli LContractOrgUnitGroup

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli LContractOrgUnitGroup

Definicja klucza Identifier_1 tabeli LContractOrgUnitGroup

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment